WaterCAD 2024 Help

Using Queries

A query in WaterCAD 2024 is a user-defined SQL expression that applies to a single element type. You use the Query Manager to create and store queries; you use the Query Builder dialog box to construct the actual SQL expression.

Queries can be one of the following three types:

  • Hydraulic Model queries—Queries you define that are available only in the WaterCAD 2024 hydraulic model in which you define them.
  • Shared queries—Queries you define that are available in all WaterCAD 2024 hydraulic models you create. You can edit shared queries.
  • Predefined queries—Factory-defined queries included with WaterCAD 2024 that are available in all hydraulic models you create. You cannot edit predefined queries.

You can also use queries in the following ways: